﻿<!DOCTYPE html>
<html>
	<head>
		<title>Edit pivot tables</title>
		<meta charset="utf-8" />
        <meta name="description" content="Change the appearance of existing pivot tables in a spreadsheet." />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Edit pivot tables</h1>
            <p class="note"><b>Note</b>: this option is available in the <em>online version</em> only.</p>
			<p>You can change the appearance of existing pivot tables in a spreadsheet using the editing tools available at the <b>Pivot Table</b> tab of the top toolbar.</p>
            <p>Select at least one cell within the pivot table with the mouse to activate the editing tools at the top toolbar.</p>
            <p><img alt="Pivot Table tab" src="../images/pivottoptoolbar.png" /></p>
            <p>The <div class = "icon icon-pivotselecticon"></div> <b>Select</b> button allows to select the entire pivot table.</p>
            <p>The rows and columns options allow you to emphasize certain rows/columns applying a specific formatting to them, or highlight different rows/columns with the different background colors to clearly distinguish them. The following options are available:</p>
            <ul>
                <li><b>Row Headers</b> - allows to highlight the row headers with a special formatting.</li>
                <li><b>Column Headers</b> - allows to highlight the column headers with a special formatting.</li>
                <li><b>Banded Rows</b> - enables the background color alternation for odd and even rows.</li>
               <li><b>Banded Columns</b> - enables the background color alternation for odd and even columns.</li>
            </ul>
            <p>
                The template list allows you to choose one of the predefined pivot table styles. Each template combines certain formatting parameters, such as a background color, border style, row/column banding etc.
                Depending on the options checked for rows and columns, the templates set will be displayed differently. For example, if you've checked the <b>Row Headers</b> and <b>Banded Columns</b> options, the displayed templates list will include only templates with the row headers highlighted and banded columns enabled.
            </p>
		</div>
	</body>
</html>